﻿use RDW
go

insert   MailTemplate(Subject,Template,Name)   values(N'ASB R&D Window System : Lab Closed Reminder'	,	N'<p>Dear Mr./Ms. {0},<br /> 
<br />
&nbsp;&nbsp;&nbsp; We are so sorry to remind you that we will have to close the lab {1} on {2} due to {3}reason.You former request will be cancelled.Any question or problem, please no hesitate to contact with mailbox of {4} or {5} directly.<br />
<br />
Thanks for your kind support<br />
&nbsp;ASB R&amp;D Window System<br />
<br />
{6} 同事, 您好:<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp; 我们非常抱歉的通知您，由于{7}的原因，我们将在{8}关闭{9}实验室。您之前提交的参观申请将不能如期举行，由此给您带来的不便敬请谅解!如有任何问题, 请发送邮件至邮箱 {10} 或直接致电{11}.&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp; 我们将竭诚为您服务.<br />
<br />
致礼 <br />
上海贝尔研发之窗系统</p>'	,	N'LabClosedReminderTemplate'	)
insert   MailTemplate(Subject,Template,Name)   values(N'ASB R&D Window System : Product Inactive Reminder'	,	N'Dear Mr./Ms. {0},<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; We are so sorry to remind you that product {1} is inactive now.You former visiting request will be cancelled.Any question or problem, please no hesitate to contact with mailbox of {2} or {3} directly.<br />
<br />
Thanks for your kind support<br />
ASB R&amp;D Window System<br />
<br />
{4} 同事, 您好:<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 我们非常抱歉的通知您，产品{5}目前无法提供参观功能。您之前提交的参观申请将不能如期举行，由此给您带来的不便敬请谅解!如有任何问题, 请发送邮件至邮箱 {6} 或直接致电{7}. <br />
我们将竭诚为您服务.<br />
<br />
致礼<br />  
上海贝尔研发之窗系统'	,	N'ProductInactiveReminderTemplate'	)
insert   MailTemplate(Subject,Template,Name)   values(N' ASB R&D Window System : Approval Reminder'	,	N'Dear Manager,&nbsp;<br />  
<br />  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;This is a kindly reminder that there is one visiting request need your approval.&nbsp;<br />  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The link is: {0}<br />  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Any question or problem, please no hesitate to contact with mailbox of {1} or {2} directly.<br />  
<br />  
Thanks for your kind support <br />  
ASB&amp;D Window System <br />  
<br />  
您好:<br />  
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;此邮件提醒您, 有一个参观申请需要您的审批.&nbsp;<br />  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;申请链接地址为: {3}<br />  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;谢谢!如有任何问题,请发送邮件至邮箱 {4} 或直接致电{5}. 我们将竭诚为您服务.<br />  
<br />  
致礼 <br />  
上海贝尔研发之窗系统'	,	N'ApprovalReminderTemplate'	)
insert   MailTemplate(Subject,Template,Name)   values(N'ASB R&D Window System : Request Cancelled Reminder'	,	N'<p>Dear Manager,<br />  
<br />  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;This is a kindly reminder that {0} has cancelled the visiting request of lab {1} on {2}/{3}/{4}.&nbsp;<br />  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The link is: {5}<br />  
&nbsp;&nbsp;&nbsp;&nbsp; Any question or problem, please no hesitate to contact with mailbox of {6} or {7} directly.<br />  
<br />  
Thanks for your kind support <br />  
ASB R&amp;D Window System <br />  
<br />
您好:<br />  
<br />  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;此邮件提醒您, 申请人{8}取消了对{9}实验室在{10}/{11}/{12}的参观申请.<br />  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;申请链接地址为: {13}<br />  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;谢谢!如有任何问题, 请发送邮件至邮箱 {14}&nbsp;或直接致电{15}. 我们将竭诚为您服务.<br />  
<br />  
致礼 <br />  
上海贝尔研发之窗系统</p>'	,	N'RequestCancelledReminderTemplate'	)
insert   MailTemplate(Subject,Template,Name)   values(N'ASB R&D Window System : Approved Reminder'	,	N'<p>Dear Mr./Ms. {0},<br />  
<br />  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;This is a kindly reminder that your visiting request of R&amp;D lab {1} has been final approved by R&amp;D Center Manager. Please remember to be present on {2}/{3}/{4} on time.<br />  
&nbsp;&nbsp;&nbsp;&nbsp; The link is: {5}<br />  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Any question or problem, please no hesitate to contact with mailbox of {6} or {7} directly.<br />  
<br />  
Thanks for your kind support <br />  
ASB R&amp;D Window System <br />  
<br />  
{8} 同事, 您好:<br />  
<br />  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;此邮件提醒您, 您提交的对{9}实验室的参观申请已经通过审批，请与当日({10}/{11}/{12})准时出席.谢谢!<br />  
&nbsp;&nbsp;&nbsp;&nbsp; 链接地址为：{13}<br />  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;如有任何问题, 请发送邮件至邮箱 {14} 或直接致电{15}. 我们将竭诚为您服务.<br />  
<br />  
致礼 <br />  
上海贝尔研发之窗系统</p>'	,	N'ApprovedReminderTemplate'	)
insert   MailTemplate(Subject,Template,Name)   values(N'ASB R&D Window System : Rejected Reminder'	,	N'Dear Mr./Ms.{0},<br />  
<br />  
&nbsp;&nbsp;&nbsp;&nbsp; This is a kindly reminder that your visiting request of R&amp;D lab {1} has been final rejected by R&amp;D Center Manager.<br /> 
&nbsp;&nbsp;&nbsp;&nbsp; The link is: {2}<br />  
&nbsp;&nbsp;&nbsp;&nbsp; Any question or problem, please no hesitate to contact with mailbox of {3} or {4} directly. <br />  
<br />  
Thanks for your kind support <br />  
ASB R&amp;D Window System<br />  
<br />  
{5} 同事, 您好:<br />  
<br />  
&nbsp;&nbsp;&nbsp;&nbsp; 此邮件提醒您, 您提交的对{6}实验室的参观申请最终未通过审批。<br />  
&nbsp;&nbsp;&nbsp;&nbsp; 链接地址为：{7}<br />  
&nbsp;&nbsp;&nbsp;&nbsp; 如有任何问题, 请发送邮件至邮箱 {8} 或直接致电{9}. 我们将竭诚为您服务。 <br />  
<br />  
致礼 <br />  
上海贝尔研发之窗系统'	,	N'RejectedReminderTemplate'	)
insert   MailTemplate(Subject,Template,Name)   values(N'ASB R&D Window System : Ask For More Reminder'	,	N'Dear Mr./Ms.{0},<br />  
<br />  
&nbsp;&nbsp;&nbsp;&nbsp; This is a kindly reminder that your visiting request of R&amp;D lab {1} has been asked for more information by R&amp;D Center Manager. Please provide your comments in the system timely.<br />  
&nbsp;&nbsp;&nbsp;&nbsp; The link is: {2}<br />  
&nbsp;&nbsp;&nbsp;&nbsp; Any question or problem, please no hesitate to contact with mailbox of {3} or {4} directly.<br />  
<br />  
Thanks for your kind support ASB <br />  
R&amp;D Window System <br />  
<br />  
{5} 同事, 您好:<br />  
<br />  
&nbsp;&nbsp;&nbsp;&nbsp; 此邮件提醒您, 您提交的对{6}实验室的参观申请被要求提供更多的信息，请及时在系统中提供评论内容。<br />  
&nbsp;&nbsp;&nbsp;&nbsp; 链接地址为：{7}<br />  
&nbsp;&nbsp;&nbsp;&nbsp; 如有任何问题, 请发送邮件至邮箱 {8} 或直接致电{9}. 我们将竭诚为您服务. <br />  
<br />
致礼 <br />  
上海贝尔研发之窗系统'	,	N'AskForMoreReminderTemplate'	)
insert   MailTemplate(Subject,Template,Name)   values(N'ASB R&D Window System : Reminder After Ask For More'	,	N'Dear Manager,<br />  
<br />  
&nbsp;&nbsp;&nbsp;&nbsp; This is a kindly reminder that the applicant has provided comments for visting request of lab {0} in the system. Please examin and approve it. <br />  
&nbsp;&nbsp;&nbsp;&nbsp; The link is: {1}<br />  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Any question or problem, please no hesitate to contact with mailbox of {2} or {3} directly.<br />  
<br />  
Thanks for your kind support <br />  
ASB R&amp;D Window System<br />  
&nbsp;<br />  
您好:<br /> 
&nbsp;&nbsp;&nbsp;&nbsp; 此邮件提醒您, 申请人已提供对{4}实验室的参观申请的评论内容，请您再次审批。<br />  
&nbsp;&nbsp;&nbsp;&nbsp; 申请链接地址为: {5}<br />  
&nbsp;&nbsp;&nbsp;&nbsp; 谢谢!如有任何问题, 请发送邮件至邮箱 {6}&nbsp;或直接致电{7}. 我们将竭诚为您服务. <br />  
<br />  
致礼<br />  
上海贝尔研发之窗系统'	,	N'ApprovalReminderAfterAskForMoreTemplate'	)
insert   MailTemplate(Subject,Template,Name)   values(N'ASB R&D Window System : Complete Feedback Survey Reminder'	,	N'Dear Mr./Ms.{0},<br />  
<br />  
&nbsp;&nbsp;&nbsp;&nbsp; Thanks for your visiting of R&amp;D lab. Please cooperate to complete the visit feedback survey in the system. <br />  
&nbsp;&nbsp;&nbsp;&nbsp; The link is: {1}<br />  
&nbsp;&nbsp;&nbsp;&nbsp; Any question or problem, please no hesitate to contact with mailbox of {2} or {3} directly. <br />  
<br />  
Thanks for your kind support<br />  
ASB R&amp;D Window System<br />  
<br />  
{4} 同事, 您好:<br />  
&nbsp;&nbsp;&nbsp;&nbsp; 非常感谢您对研发中心实验室的参观, 请您配合完成对此次参观的反馈调查。<br />  
&nbsp;&nbsp;&nbsp;&nbsp; 链接地址为: {5}<br />  
&nbsp;&nbsp;&nbsp;&nbsp; 谢谢!如有任何问题, 请发送邮件至邮箱 {6}&nbsp;或直接致电{7}. 我们将竭诚为您服务. <br />  
<br />  
致礼<br />  
上海贝尔研发之窗系统'	,	N'CompleteFeedbackSurveyReminderTemplate'	)
